GET
  FILE='D:\Longitudinal Data\Patient Master 1991 to 2001.sav'.
CROSSTABS
  /TABLES=numclam  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 18:30:55
Comments
Input Data D:\Longitudinal Data\Patient Master 1991 to 2001.sav
File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 82537
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=numclam BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:00.94

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
NUMCLAM * PATSEX 82537 100.0% 0 .0% 82537 100.0%


NUMCLAM * PATSEX Crosstabulation
Count

PATSEX Total
F M
NUMCLAM 1 5103 5253 10356
2 3942 3953 7895
3 3491 3421 6912
4 3112 2882 5994
5 2822 2507 5329
6 2512 2108 4620
7 2226 1826 4052
8 2048 1753 3801
9 1898 1512 3410
10 1752 1388 3140
11 1588 1227 2815
12 1420 1184 2604
13 1414 1013 2427
14 1259 970 2229
15 1145 854 1999
16 1098 782 1880
17 1030 796 1826
18 943 652 1595
19 919 646 1565
20 845 589 1434
21 770 552 1322
22 671 434 1105
23 512 373 885
24 372 267 639
25 288 224 512
26 242 138 380
27 194 141 335
28 165 103 268
29 130 84 214
30 85 65 150
31 66 53 119
32 65 36 101
33 63 30 93
34 41 28 69
35 49 27 76
36 40 21 61
37 39 15 54
38 23 15 38
39 20 9 29
40 12 10 22
41 19 7 26
42 19 8 27
43 13 11 24
44 8 6 14
45 7 2 9
46 5 3 8
47 11 2 13
48 7 3 10
49 1 2 3
50 3 1 4
51 4
4
52 2 1 3
53 2
2
54 2
2
55 2
2
56 1
1
57 1 1 2
58 1
1
59 2
2
60 1 1 2
62 4
4
64 2
2
67 1
1
69 1 1 2
71 1
1
76 1
1
81 1
1
82 1
1
85 1
1
88 1
1
95 1
1
109 1
1
114 1
1
117 1
1
126 1
1
131 1
1
165 1
1
249 1
1
Total 44547 37990 82537 

GET
  FILE='D:\Longitudinal Data\Claims Master 1991 to 2001 all patients.sav'.
GET
  FILE='D:\Longitudinal Data\Claims Master 1991 to 2001.sav'.
GET
  FILE='D:\Longitudinal Data\Teeth Treated 1991 to 2001.sav'.
CROSSTABS
  /TABLES=trtcode  BY patsex quadrant tooth
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 18:40:25
Comments
Input Data D:\Longitudinal Data\Teeth Treated 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 949072
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=trtcode BY patsex quadrant tooth
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:22.13

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
TRTCODE * PATSEX 949072 100.0% 0 .0% 949072 100.0%
TRTCODE * QUADRANT 949072 100.0% 0 .0% 949072 100.0%
TRTCODE * TOOTH 949072 100.0% 0 .0% 949072 100.0%


TRTCODE * PATSEX Crosstabulation
Count

PATSEX Total
F M
TRTCODE 701 41 24 65
1101 189 168 357
1102 192 143 335
1111 164 97 261
1112 132 81 213
1131 605 549 1154
1401 39336 37708 77044
1402 8633 8320 16953
1403 77509 71715 149224
1404 32368 28696 61064
1411 164 148 312
1421 69341 62150 131491
1422 8501 7712 16213
1423 1834 1931 3765
1424 599 685 1284
1425 1410 1041 2451
1426 34923 32349 67272
1431 16250 15991 32241
1441 3445 2431 5876
1442 1066 663 1729
1443 1162 735 1897
1444 2732 1833 4565
1461 233 195 428
1501 18380 16662 35042
1511 1 1 2
1521 336 237 573
1522 73 51 124
1523 12 7 19
1531 3 2 5
1541 295 210 505
1601 1541 830 2371
1701 35 7 42
1702 194 174 368
1703 4 3 7
1704 1066 920 1986
1705 70 48 118
1706 1607 1680 3287
1711 2015 1820 3835
1712 272 245 517
1716 870 460 1330
1721 19738 15935 35673
1722 766 596 1362
1723 83 36 119
1726 40 28 68
1727 7 8 15
1731 2319 2228 4547
1732 1858 1881 3739
1733 1218 1074 2292
1734 5934 5100 11034
1735 9
9
1736 46 35 81
1737 34 22 56
1738 29 30 59
1739 50 24 74
1744 31 35 66
1751 8 12 20
1761 7 3 10
1762 24 19 43
1771 105 90 195
1781 697 602 1299
1782 8941 7855 16796
1801 20 13 33
1802 11 9 20
1803 38 24 62
1804 20 21 41
1805 2 3 5
1806 7 2 9
1807 3413 3056 6469
1808 122 98 220
1811 253 205 458
1812 27 36 63
1813 59 57 116
1814 295 226 521
1815 38 22 60
1816 21 10 31
1821 37 18 55
1822 8 11 19
1823 4 2 6
1824 4 7 11
1825 2265 2035 4300
1826 82 65 147
1827 7 3 10
1831 461 460 921
1832 265 269 534
1841
15 15
2101 29520 29341 58861
2201 3164 3274 6438
2202 572 651 1223
2203 3708 3600 7308
2204 896 522 1418
2205 491 452 943
2733 49430 44771 94201
2743 3381 3810 7191
2744 3618 3174 6792
2745 3328 3407 6735
2746 113 259 372
2751 61 85 146
2863 5119 4826 9945
3261 2
2
3263 3
3
3611 8306 6180 14486
3651 1 2 3
3661 357 230 587
3671 144 226 370
3803 1
1
4003 84 75 159
4005 14 18 32
4007 129 135 264
4008 495 363 858
4009 108 120 228
4011 60 63 123
4012 2 8 10
4014 40 45 85
4015 5 8 13
5001 701 593 1294
5021 96 108 204
5031 101 98 199
5032 135 135 270
5041 99 96 195
5075 28 17 45
5104 1 1 2
5111 28 30 58
5112 358 249 607
5201 440 561 1001
5211 35 51 86
5212 5 6 11
5213 56 61 117
5214 10 5 15
5215 4 3 7
5563 16 29 45
5811 30 34 64
5812 21 15 36
5813 118 98 216
5814 64 43 107
5821 132 74 206
5822 41 23 64
5823 5 2 7
5824 6 2 8
5825 7 2 9
5826 107 75 182
5831 56 50 106
5836 8 3 11
5841 47 43 90
5903 38 9 47
6201 500 402 902
6211 251 267 518
6221 171 102 273
6231 571 377 948
6241 90 97 187
6251 17 18 35
6263 28 6 34
6264 26 16 42
6265 39 14 53
6273
10 10
6274 3 9 12
6275 4 2 6
6283 13 15 28
6284 50 30 80
6285 24 38 62
6301 1032 896 1928
6321 111 81 192
6331 130 126 256
6332 192 176 368
6341 239 225 464
6351 178 119 297
6401 9 5 14
6405 1 1 2
6499 1
1
6501 4 3 7
6511 57 72 129
6512 8 7 15
6513 1
1
6521 10 15 25
6522 17 19 36
6523
3 3
6599 20 10 30
Total 496748 452324 949072


TRTCODE * QUADRANT Crosstabulation
Count

QUADRANT Total
LL LR UL UR
TRTCODE 701 15 17 16 17 65
1101

169 188 357
1102 166 169

335
1111

146 115 261
1112 114 99

213
1131 215 173 365 401 1154
1401 20507 19663 18607 18267 77044
1402 4379 4219 4206 4149 16953
1403 35175 35281 40180 38588 149224
1404 12128 12073 19110 17753 61064
1411 77 73 89 73 312
1421 20281 19545 45907 45758 131491
1422 1683 1657 6315 6558 16213
1423 838 755 1049 1123 3765
1424 215 190 443 436 1284
1425 404 382 834 831 2451
1426 16406 15786 17432 17648 67272
1431 7780 7486 8673 8302 32241
1441 1499 1498 1479 1400 5876
1442 450 463 414 402 1729
1443 519 518 425 435 1897
1444 1272 1240 1031 1022 4565
1461 109 108 110 101 428
1501 6817 6813 10807 10605 35042
1511 1 1

2
1521 39 38 255 241 573
1522 2 9 46 67 124
1523

11 8 19
1531 3 2

5
1541 26 29 221 229 505
1601

1172 1199 2371
1701 14 10 8 10 42
1702 89 95 85 99 368
1703

3 4 7
1704 510 465 495 516 1986
1705 29 35 30 24 118
1706 1048 934 695 610 3287
1711 1175 1055 834 771 3835
1712 130 166 114 107 517
1716 73 79 600 578 1330
1721 4992 5038 12921 12722 35673
1722 151 161 545 505 1362
1723 6 10 49 54 119
1726 9 5 21 33 68
1727 2 2 4 7 15
1731 465 444 1851 1787 4547
1732 423 450 1441 1425 3739
1733 337 339 806 810 2292
1734 2264 2233 3349 3188 11034
1735 1 2 2 4 9
1736 23 17 24 17 81
1737 15 15 11 15 56
1738 14 13 16 16 59
1739 14 17 21 22 74
1744 4 3 26 33 66
1751 3 6 5 6 20
1761 2 2 3 3 10
1762 4 4 18 17 43
1771 18 13 83 81 195
1781 221 250 383 445 1299
1782 2056 1897 6334 6509 16796
1801 2 5 12 14 33
1802 4 2 4 10 20
1803 19 12 10 21 62
1804 3 4 16 18 41
1805
1 1 3 5
1806

4 5 9
1807 665 633 2567 2604 6469
1808 24 21 86 89 220
1811 21 16 200 221 458
1812 3 3 25 32 63
1813 9 7 51 49 116
1814 91 81 182 167 521
1815 5 7 27 21 60
1816 2
7 22 31
1821 13 9 14 19 55
1822 3 4 5 7 19
1823 3
2 1 6
1824 2 2 4 3 11
1825 461 424 1701 1714 4300
1826 12 17 52 66 147
1827 1 1 2 6 10
1831 138 138 307 338 921
1832 78 77 187 192 534
1841
3 9 3 15
2101 11685 12226 17623 17327 58861
2201 1306 1272 1999 1861 6438
2202 101 96 497 529 1223
2203 1687 1702 2007 1912 7308
2204 425 401 298 294 1418
2205 390 408 74 71 943
2733 17368 17449 29713 29671 94201
2743 968 974 2711 2538 7191
2744 2460 2369 971 992 6792
2745 570 543 2791 2831 6735
2746 15 19 170 168 372
2751 6 6 68 66 146
2863 1493 1549 3461 3442 9945
3261

2
2
3263

2 1 3
3611 3317 3212 4087 3870 14486
3651


3 3
3661 116 114 185 172 587
3671 47 48 130 145 370
3803 1


1
4003 59 70 16 14 159
4005 10 7 9 6 32
4007 80 68 58 58 264
4008 105 103 328 322 858
4009 27 26 90 85 228
4011 9 8 60 46 123
4012 1
2 7 10
4014 7 9 38 31 85
4015

7 6 13
5001 329 299 329 337 1294
5021 46 42 70 46 204
5031 37 38 52 72 199
5032 63 58 68 81 270
5041 40 59 53 43 195
5075 11 8 15 11 45
5104

2
2
5111 11 10 16 21 58
5112 42 55 238 272 607
5201 222 248 267 264 1001
5211 18 21 26 21 86
5212 2
5 4 11
5213 31 34 23 29 117
5214 7 3 3 2 15
5215 2 3 1 1 7
5563 7 7 14 17 45
5811 23 18 7 16 64
5812 10 9 10 7 36
5813 61 62 42 51 216
5814 25 28 28 26 107
5821 22 25 77 82 206
5822 4 6 26 28 64
5823 1 2 1 3 7
5824 2 1 3 2 8
5825

4 5 9
5826 42 43 51 46 182
5831 23 32 27 24 106
5836 1 3 2 5 11
5841 17 17 26 30 90
5903 9 15 10 13 47
6201 157 166 284 295 902
6211 93 91 168 166 518
6221 45 46 88 94 273
6231 141 135 333 339 948
6241 39 29 54 65 187
6251 1 2 16 16 35
6263 7 7 12 8 34
6264 16 15 4 7 42
6265 7 8 17 21 53
6273 2 2 3 3 10
6274 3 6 1 2 12
6275

2 4 6
6283 5 5 9 9 28
6284 27 32 10 11 80
6285 7 10 23 22 62
6301 479 446 501 502 1928
6321 40 44 63 45 192
6331 44 44 78 90 256
6332 75 92 96 105 368
6341 97 106 136 125 464
6351 77 61 66 93 297
6401

8 6 14
6405

1 1 2
6499


1 1
6501 1 1 3 2 7
6511 23 15 53 38 129
6512 3 1 8 3 15
6513
1

1
6521 5 10 5 5 25
6522 13 7 9 7 36
6523
1 1 1 3
6599 3 5 12 10 30
Total 191542 188727 286721 282082 949072


TRTCODE * TOOTH Crosstabulation
Count

TOOTH Total
1 2 3 4 5 6 7 8
TRTCODE 701





2 63 65
1101 54 59 52 51 48 52 35 6 357
1102 36 39 40 32 40 62 59 27 335
1111 46 45 37 32 29 31 28 13 261
1112 43 40 34 23 21 24 22 6 213
1131 155 157 134 164 188 193 142 21 1154
1401 743 754 1492 4444 6529 20509 28686 13887 77044
1402 53 51 560 536 884 6562 6175 2132 16953
1403


20573 30832 46582 40760 10477 149224
1404


9348 16490 21015 12451 1760 61064
1411


46 70 100 82 14 312
1421 34957 30252 31920 14525 9185 6587 3350 715 131491
1422 8222 5158 2833




16213
1423 1887 891 987




3765
1424 681 380 223




1284
1425


869 859 723

2451
1426 6321 6466 11271 11691 9218 11013 8469 2823 67272
1431 1235 1086 924 3437 5428 11038 7736 1357 32241
1441 15 48 3 863 987 1234 1797 929 5876
1442 14 10 8 210 251 482 552 202 1729
1443 3 2 1 177 230 502 655 327 1897
1444 4 11 3 420 531 1393 1621 582 4565
1461 14 8 30 56 64 100 102 54 428
1501 3421 3544 3047 4760 7619 7651 4440 560 35042
1511





2
2
1521 271 226 76




573
1522


72 52


124
1523




17 2
19
1531




4 1
5
1541 195 153 53 50 41 12 1
505
1601 1326 708 337




2371
1701 1 1 3 2 3 10 18 4 42
1702 1 1 3 39 66 159 85 14 368
1703 5 2





7
1704 3 2 3 163 283 902 570 60 1986
1705 4 2 2 13 18 48 29 2 118
1706


88 219 1391 1368 221 3287
1711 11 13 7 49 89 1993 1477 196 3835
1712 9 8 4 1 14 269 197 15 517
1716 743 451 82 35 18 1

1330
1721 7304 6065 3334 5456 7426 4297 1655 136 35673
1722 311 276 151 236 325 43 19 1 1362
1723 66 42 3 2 3 2 1
119
1726 14 17 7 10 9 9 2
68
1727 5 2
3 1 4

15
1731 1060 1173 668 575 900 102 62 7 4547
1732 715 890 546 535 886 97 66 4 3739
1733 301 387 255 364 519 285 166 15 2292
1734 716 644 445 1726 2373 3092 1828 210 11034
1735 1

2 2 3 1
9
1736 1 1 3 4 4 39 27 2 81
1737 1
2 4 7 24 18
56
1738
2 10 17 9 10 7 4 59
1739 5 6 16 19 7 13 5 3 74
1744 23 26 5 8 4


66
1751 4 2 1 2 4 3 4
20
1761 4
1 1
2 1 1 10
1762 11 9 8 5 4 5 1
43
1771 36 57 22 28 22 23 7
195
1781 200 217 78 142 158 292 178 34 1299
1782 3578 4131 2226 1809 2405 1431 1030 186 16796
1801 4 4 7 8 7 2 1
33
1802

3 6 5 3 3
20
1803 2 2 8 5 9 15 17 4 62
1804 5 2 3 7 5 2 14 3 41
1805


1
2 2
5
1806 4 4 1




9
1807 1066 950 1477 809 860 639 623 45 6469
1808 40 30 55 25 29 24 16 1 220
1811 132 112 121 28 49 9 7
458
1812 17 8 19 7 9 2 1
63
1813 28 19 29 13 18 2 6 1 116
1814 41 32 52 79 104 119 84 10 521
1815 5 5 15 15 13 5 2
60
1816 2 2 8 6 7 3 3
31
1821 4 4 1 11 13 17 4 1 55
1822 1 1
2 7 7 1
19
1823


2 3 1

6
1824 6 5





11
1825 948 923 302 667 770 647 42 1 4300
1826 33 44 9 19 25 16 1
147
1827
1
3 2 4

10
1831 260 255 228 49 76 23 30
921
1832 244 143 36 58 21 30 2
534
1841 1 1 2 3 3 2 2 1 15
2101 6016 5874 4109 6073 7236 8422 10633 10498 58861
2201 310 391 330 632 833 1302 1197 1443 6438
2202 258 432 533




1223
2203


910 1222 2454 1965 757 7308
2204






1418 1418
2205






943 943
2733 13629 13347 6564 13420 15774 18290 12798 379 94201
2743 851 904 463 1114 1346 1514 980 19 7191
2744 585 521 224 873 1354 1906 1286 43 6792
2745 788 881 443 1048 1249 1439 856 31 6735
2746 127 140 69 19 8 5 4
372
2751 18 23 14 21 21 21 22 6 146
2863 1999 2082 1974 1565 1087 622 539 77 9945
3261




1 1
2
3263
2
1



3
3611 2978 1503 996 1188 1454 3101 2546 720 14486
3651 1




2
3
3661 15 11 18 56 101 237 137 12 587
3671 68 74 118 56 40 7 6 1 370
3803
1





1
4003 74 37 15 27 6


159
4005 5
3 5 4 4 8 3 32
4007
3
5 6 143 92 15 264
4008 200 154 93 181 230


858
4009 46 44 34 33 60 5 6
228
4011 23 18 30 21 11 14 6
123
4012 4 1 4
1


10
4014 21 25 10 7 16 6

85
4015 5 3 2 2
1

13
5001 84 44 37 122 194 428 301 84 1294
5021 30 28 17 27 31 45 24 2 204
5031 27 36 29 27 56 14 9 1 199
5032 2 2 1 22 34 135 64 10 270
5041 22 13 9 9 25 62 42 13 195
5075 3
1 6 10 19 6
45
5104 1 1





2
5111 8 11 4 6 5 13 10 1 58
5112 194 177 67 51 51 44 22 1 607
5201 47 32 37 81 144 212 267 181 1001
5211 2 5 3 6 14 17 18 21 86
5212 2 3 6




11
5213


12 8 49 34 14 117
5214






15 15
5215






7 7
5563 17 7 12 3 4
2
45
5811 2
2 6 7 20 21 6 64
5812



4 15 11 6 36
5813


23 32 77 76 8 216
5814


8 22 45 29 3 107
5821 78 51 34 14 10 11 7 1 206
5822 42 15 7




64
5823 4 2 1




7
5824 4 4





8
5825


1 6 2

9
5826 18 10 17 20 26 50 25 16 182
5831 4 6 4 7 23 30 29 3 106
5836 1 1 2 1 1 3 2
11
5841 8 8 13 7 18 27 8 1 90
5903 6 5 4 9 9 9 5
47
6201 117 109 73 119 146 176 153 9 902
6211 76 59 48 68 82 101 80 4 518
6221 39 38 27 32 39 48 47 3 273
6231 158 138 88 122 138 169 128 7 948
6241 23 22 16 24 31 38 32 1 187
6251 6 6 5 5 5 3 5
35
6263
1 3 6 9 7 8
34
6264 4 3 2 6 8 12 7
42
6265 8 6 2 7 7 13 8 2 53
6273


1 1 4 4
10
6274 2 1
1 1 4 3
12
6275 3 3





6
6283 2 3 1 4 5 7 5 1 28
6284 4 4 3 16 16 21 15 1 80
6285 8 10 4 6 12 14 8
62
6301 78 71 75 193 335 581 432 163 1928
6321 20 28 15 22 34 41 23 9 192
6331 31 48 38 21 75 25 14 4 256
6332 5 3 2 41 40 148 104 25 368
6341 25 36 28 45 84 153 79 14 464
6351 18 21 16 35 65 81 54 7 297
6401 10 3 1




14
6405


1
1

2
6499



1


1
6501 1 2
1 2 1

7
6511 22 24 11 21 29 13 8 1 129
6512 2 2 1 3 5
2
15
6513

1




1
6521


1 2 16 5 1 25
6522

1 1 1 17 16
36
6523




2
1 3
6599 6 5 3 2 6 5 3
30
Total 106967 94640 81143 114069 141381 194531 162192 54149 949072 

Sort cases by claimIDn.
Aggregate outfile=*
 /presorted
 /break claimIDn
 /patage patsex
 = first (patage patsex).
* Age/Sex for claims containing tooth treatments.

CROSSTABS
  /TABLES=patage  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 18:58:16
Comments
Input File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 357570
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=patage BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:02.27

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
PATAGE * PATSEX 357570 100.0% 0 .0% 357570 100.0%


PATAGE * PATSEX Crosstabulation
Count

PATSEX Total
F M
PATAGE 18 2199 1897 4096
19 1792 1536 3328
20 2400 1940 4340
21 2412 1931 4343
22 2586 2061 4647
23 2947 2195 5142
24 2797 2229 5026
25 3398 2465 5863
26 3583 2564 6147
27 4009 2939 6948
28 4104 2846 6950
29 4148 2977 7125
30 4821 3389 8210
31 4575 3237 7812
32 4601 3373 7974
33 4577 3441 8018
34 4482 3365 7847
35 4694 3545 8239
36 4660 3677 8337
37 4458 3490 7948
38 4168 3419 7587
39 4281 3442 7723
40 4589 3618 8207
41 4326 3456 7782
42 4403 3460 7863
43 4195 3426 7621
44 4467 3654 8121
45 4446 3700 8146
46 4340 3640 7980
47 4250 3412 7662
48 4077 3391 7468
49 4410 3615 8025
50 4290 3442 7732
51 3669 3037 6706
52 3656 2959 6615
53 3342 2772 6114
54 3688 3141 6829
55 3261 2856 6117
56 3095 2712 5807
57 3003 2681 5684
58 2930 2636 5566
59 2805 2734 5539
60 2609 2484 5093
61 2402 2511 4913
62 2493 2403 4896
63 2269 2272 4541
64 2295 2322 4617
65 2052 2278 4330
66 2037 2124 4161
67 1904 2043 3947
68 1710 1793 3503
69 1653 1778 3431
70 1520 1647 3167
71 1504 1524 3028
72 1428 1447 2875
73 1374 1407 2781
74 1144 1177 2321
75 1207 1059 2266
76 1057 954 2011
77 935 804 1739
78 851 694 1545
79 767 599 1366
80 681 525 1206
81 578 415 993
82 457 305 762
83 312 233 545
84 288 175 463
85 276 182 458
86 198 119 317
87 168 70 238
88 144 76 220
89 97 54 151
90 83 32 115
91 61 29 90
92 35 29 64
93 16 3 19
94 21 2 23
95 13 5 18
96 9 2 11
97 6 3 9
98 7 4 11
99 16 14 30
100 11 8 19
101 10 7 17
102 4 2 6
103 5 4 9
104 1 2 3
105 2 2 4
106 1
1
107 1 1 2
110
1 1
Total 195646 161924 357570 

GET
  FILE='D:\Longitudinal Data\All filling claims 1991 to 2001.sav'.
GET  FILE=
 'D:\Longitudinal Data\Expanded Observed Restoration Lives 1991 to 2001.sav'.
GET
  FILE='D:\Longitudinal Data\Longitudinal Analysis Age group Master 1991 to'+
 ' 2001.sav'.
CROSSTABS
  /TABLES=tooth  BY quadrant
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 19:14:28
Comments
Input Data D:\Longitudinal Data\Longitudinal Analysis Age group Master 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 843894
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=tooth BY quadrant
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:21.22

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Tooth position * Mouth quadrant 843894 100.0% 0 .0% 843894 100.0%


Tooth position * Mouth quadrant Crosstabulation
Count

Mouth quadrant Total
LL LR UL UR
Tooth position 1 6826 6501 28458 28140 69925
2 7376 6890 24884 24114 63264
3 11721 11041 26750 25123 74635
4 21498 21064 29176 30933 102671
5 30447 30477 31485 31932 124341
6 45474 45814 48166 46848 186302
7 43249 42206 42447 40062 167964
8 15564 14285 12784 12159 54792
Total 182155 178278 244150 239311 843894 

CROSSTABS
  /TABLES=patagegr  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 19:17:56
Comments
Input Data D:\Longitudinal Data\Longitudinal Analysis Age group Master 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 843894
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=patagegr BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:21.52

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Patient age (years) * patient sex 843894 100.0% 0 .0% 843894 100.0%


Patient age (years) * patient sex Crosstabulation
Count

patient sex Total
F M
Patient age (years) 18 or 19 11991 12026 24017
20 to 29 96086 83329 179415
30 to 39 108371 94133 202504
40 to 49 91531 83822 175353
50 to 59 65503 62087 127590
60 to 69 38687 43129 81816
70 to 79 20951 21193 42144
80 or older 6424 4631 11055
Total 439544 404350 843894 

CROSSTABS
  /TABLES=maintrt  BY patagegr  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 19:21:57
Comments
Input Data D:\Longitudinal Data\Longitudinal Analysis Age group Master 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 843894
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=maintrt BY patagegr BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 3
Cells Available 95325
Elapsed Time 0:00:22.95

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Main Treatment * Patient age (years) * patient sex 843894 100.0% 0 .0% 843894 100.0%


Main Treatment * Patient age (years) * patient sex Crosstabulation
Count

Patient age (years) Total
patient sex 18 or 19 20 to 29 30 to 39 40 to 49 50 to 59 60 to 69 70 to 79 80 or older
F Main Treatment Single surface amalgam 4238 25188 16749 10152 6112 3329 1818 480 68066
Two surface amalgam, not MO or DO 579 3980 3577 2753 1765 942 459 127 14182
MO or DO amalgam 3761 33772 38027 27395 15472 7150 3017 782 129376
MOD amalgam 696 9053 14648 13746 8538 4150 1419 347 52597
Tunnel amalgam 37 115 52 23 9 9 4
249
Composite resin 1853 15921 22628 23761 21375 14850 8664 2458 111510
Glass ionomer 612 6006 9928 11142 10591 7461 5216 2155 53111
Root filling 215 2051 2762 2559 1641 796 354 75 10453
Total 11991 96086 108371 91531 65503 38687 20951 6424 439544
M Main Treatment Single surface amalgam 4027 22257 16282 9984 6213 3921 2228 458 65370
Two surface amalgam, not MO or DO 630 3744 3267 2578 1771 1060 590 124 13764
MO or DO amalgam 3689 28712 32751 26035 15693 8889 3269 544 119582
MOD amalgam 752 7680 12547 12202 7665 4055 1417 231 46549
Tunnel amalgam 28 75 59 46 17 18 2
245
Composite resin 2013 13991 19098 20660 18725 15454 8026 1747 99714
Glass ionomer 621 4701 7582 10133 10492 8766 5286 1459 49040
Root filling 266 2169 2547 2184 1511 966 375 68 10086
Total 12026 83329 94133 83822 62087 43129 21193 4631 404350 

* Reduce to claims.

Sort cases by claimIDn.

Aggregate outfile=*
 /presorted
 /break claimIDn
 /patagegr patsex patidn
 = first (patagegr patsex patidn).
CROSSTABS
  /TABLES=patagegr  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 19:34:21
Comments
Input File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 270116
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=patagegr BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:01.70

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Patient age (years) * patient sex 270116 100.0% 0 .0% 270116 100.0%


Patient age (years) * patient sex Crosstabulation
Count

patient sex Total
F M
Patient age (years) 18 or 19 3221 2805 6026
20 to 29 25863 19436 45299
30 to 39 35303 27323 62626
40 to 49 32708 27309 60017
50 to 59 24145 21148 45293
60 to 69 15113 15579 30692
70 to 79 8230 7979 16209
80 or older 2395 1559 3954
Total 146978 123138 270116 

* Reduce to patients, and number of filling claims.

Sort cases by patidn.

Aggregate outfile=*
 /presorted
 /break claimIDn
 /patsex = first(patsex)
 /nclaims=n.

>Warning # 10950
>The working file read by AGGREGATE was not in ascending sequence on the
>break variables.  It may be impossible to match the aggregated output file
>with the MATCH FILES command using the keyword BY.

GET
  FILE='D:\Longitudinal Data\Longitudinal Analysis Age group Master 1991 to'+
 ' 2001.sav'.
* Reduce to claims.

Sort cases by claimIDn.

Aggregate outfile=*
 /presorted
 /break claimIDn
 /patagegr patsex patidn
 = first (patagegr patsex patidn).
* Reduce to patients, and number of filling claims.

Sort cases by patidn.

Aggregate outfile=*
 /presorted
 /break patidn
 /patsex = first(patsex)
 /nclaims=n.

CROSSTABS
  /TABLES=nclaims  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 03-MAR-2003 19:47:47
Comments
Input File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 80443
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=nclaims BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:00.50

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
NCLAIMS * patient sex 80443 100.0% 0 .0% 80443 100.0%


NCLAIMS * patient sex Crosstabulation
Count

patient sex Total
F M
NCLAIMS 1 14702 13082 27784
2 8289 7238 15527
3 5518 4741 10259
4 4009 3295 7304
5 2959 2306 5265
6 2124 1709 3833
7 1504 1296 2800
8 1093 921 2014
9 864 697 1561
10 629 513 1142
11 439 351 790
12 306 293 599
13 217 198 415
14 168 138 306
15 136 110 246
16 81 67 148
17 67 50 117
18 40 23 63
19 34 31 65
20 26 28 54
21 25 21 46
22 14 15 29
23 5 6 11
24 7 5 12
25 11 3 14
26 3 3 6
27 6 2 8
28 2 2 4
29 3 4 7
30 1 1 2
31 1 2 3
32 1 1 2
34 1
1
35 1
1
39 1
1
43 1
1
46 1
1
48 1
1
84 1
1
Total 43291 37152 80443